The Date Format field in the System Setup window is blank by default, which causes iMIS to use the U.S. English short date and time formats used in most U.S.-based computers. For example:
■ 11/16/2007 is the short date format that represents November 16, 2007
■ 2:16:26 PM is the time format that represents 14:16:26
Tip: Use a format that displays the entire four-digit year so that users can verify the correct century. iMIS typically assumes a year of 29 or less to refer to the 21st century (30/3/22 = 30 March 2022) and 30 or higher as the 20th century (30/3/30 = 30 March 1930).
Formatting date/time outside the United States
Whenever you have the operating system of an iMIS server set for a region other than U.S. English, be sure to specify a matching Date Format in iMIS. The region is set through Control Panel > Regional and Language Options, Regional Options.
For example, if the server specifies English (United Kingdom) for the regional language, 16/11/2007 for the Short date format, and 14:16:26 for the Time format, you must make iMIS match by specifying D/M/CY H:N:S in iMIS.
To define the date/time format for iMIS
1. Log on to iMIS Desktop with the MANAGER logon.
2. Choose File > System Setup.
3. Click Edit.
4. In the Date Format field, specify a combination of variables that represents the Short date and Time formats used by the operating system of the iMIS application server. Examples:
□ m D CY H:N.S.s returns "JUN 12 2008 15:45.00.00"
□ D m Y H:N A returns "12 JUN 08 3:45 PM"
□ M/D/Y H.N returns "06/12/08 15.45"
□ YMD returns "080612"
Refer to the table below for details.
5. Click Save.
6. Restart iMIS.
|
Variable |
Description |
Example |
|
Y |
Year, 2-digit |
99 |
|
y |
Year with Century, 4-digit |
1999 |
|
C |
Century, 2-digit |
19 |
|
M |
Month, numeric |
06 |
|
m |
Month, 3-character abbr. In caps |
JUN |
|
D |
Day of month, cardinal |
12 |
|
d |
Day of month, ordinal |
12th |
|
W |
Day of week, numeric, Sunday=0, Saturday=6 |
5 |
|
w |
Day of week, full name |
Friday |
|
H |
Hour of day, 24-hour format |
0-23 |
|
h |
Hour of day, 12-hour format |
1-12 |
|
N |
Minutes, 2-digit, with leading zero |
07 |
|
S |
Seconds, 2-digit, with leading zero |
02 |
|
s |
Hundredths of seconds, 2-digit |
37 |
|
A |
AM/PM, all caps |
AM |